YData Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	12
Number of observations	2773
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	281.6 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`avg_basket_size` is highly overall correlated with `gross_revenue` and 1 other fields	High correlation
`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`avg_ticket` is highly overall correlated with `avg_unique_basket_size`	High correlation
`avg_unique_basket_size` is highly overall correlated with `avg_ticket` and 1 other fields	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`gross_revenue` is highly overall correlated with `avg_basket_size` and 3 other fields	High correlation
`qtde_produtcs` is highly overall correlated with `avg_unique_basket_size` and 3 other fields	High correlation
`qte_invoices` is highly overall correlated with `gross_revenue` and 2 other fields	High correlation
`qte_items` is highly overall correlated with `avg_basket_size` and 3 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 27.67827335)	Skewed
`frequency` is highly skewed (γ1 = 46.07740946)	Skewed
`qtde_returns` is highly skewed (γ1 = 21.6260127)	Skewed
`customer_id` has unique values	Unique
`recency_days` has 33 (1.2%) zeros	Zeros
`qtde_returns` has 1481 (53.4%) zeros	Zeros

Reproduction

Analysis started	2025-04-09 19:32:53.176116
Analysis finished	2025-04-09 19:33:28.920183
Duration	35.74 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

customer_id
Real number (ℝ)

Unique

Distinct	2773
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15285.281

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12626.6
Q1	13815
median	15241
Q3	16780
95-th percentile	17950.4
Maximum	18287
Range	5940
Interquartile range (IQR)	2965

Descriptive statistics

Standard deviation	1715.1526
Coefficient of variation (CV)	0.11220942
Kurtosis	-1.2070293
Mean	15285.281
Median Absolute Deviation (MAD)	1484
Skewness	0.016612507
Sum	42386085
Variance	2941748.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
14482	1	< 0.1%
17058	1	< 0.1%
17704	1	< 0.1%
16933	1	< 0.1%
13772	1	< 0.1%
16249	1	< 0.1%
14198	1	< 0.1%
13989	1	< 0.1%
17930	1	< 0.1%
Other values (2763)	2763	99.6%

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

gross_revenue
Real number (ℝ)

High correlation

Distinct	2759
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2844.942

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	36.56
5-th percentile	264.548
Q1	628
median	1169.94
Q3	2423.32
95-th percentile	7490.982
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1795.32

Descriptive statistics

Standard deviation	10466.686
Coefficient of variation (CV)	3.6790506
Kurtosis	372.80205
Mean	2844.942
Median Absolute Deviation (MAD)	689.02
Skewness	17.097705
Sum	7889024.2
Variance	1.0955151 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1025.44	2	0.1%
745.06	2	0.1%
889.93	2	0.1%
734.94	2	0.1%
331	2	0.1%
1314.45	2	0.1%
379.65	2	0.1%
1353.74	2	0.1%
598.2	2	0.1%
1078.96	2	0.1%
Other values (2749)	2753	99.3%

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140438.72	1	< 0.1%
124564.53	1	< 0.1%
117375.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65019.62	1	< 0.1%

recency_days
Real number (ℝ)

Zeros

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.648395

Minimum	0
Maximum	372
Zeros	33
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	372
Range	372
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.422907
Coefficient of variation (CV)	1.2078525
Kurtosis	3.4305436
Mean	56.648395
Median Absolute Deviation (MAD)	23
Skewness	1.8980349
Sum	157086
Variance	4681.6942
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	87	3.1%
2	85	3.1%
3	85	3.1%
8	76	2.7%
10	67	2.4%
9	66	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (242)	2026	73.1%

Value	Count	Frequency (%)
0	33	1.2%
1	99	3.6%
2	85	3.1%
3	85	3.1%
4	87	3.1%
5	43	1.6%
7	65	2.3%
8	76	2.7%
9	66	2.4%
10	67	2.4%

Value	Count	Frequency (%)
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%
333	2	0.1%
330	1	< 0.1%

qte_invoices
Real number (ℝ)

High correlation

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0544537

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.0729125
Coefficient of variation (CV)	1.4985518
Kurtosis	183.89793
Mean	6.0544537
Median Absolute Deviation (MAD)	2
Skewness	10.623447
Sum	16789
Variance	82.317741
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	780	28.1%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	278	10.0%

Value	Count	Frequency (%)
2	780	28.1%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

qte_items
Real number (ℝ)

High correlation

Distinct	1631
Distinct (%)	58.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1669.2236

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	119
Q1	330
median	699
Q3	1478
95-th percentile	4614
Maximum	196844
Range	196842
Interquartile range (IQR)	1148

Descriptive statistics

Standard deviation	5885.8021
Coefficient of variation (CV)	3.5260717
Kurtosis	486.75708
Mean	1669.2236
Median Absolute Deviation (MAD)	449
Skewness	18.198824
Sum	4628757
Variance	34642666
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
150	8	0.3%
246	8	0.3%
516	7	0.3%
1200	7	0.3%
200	7	0.3%
272	7	0.3%
219	7	0.3%
260	7	0.3%
300	7	0.3%
Other values (1621)	2697	97.3%

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%
33	2	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
79963	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57785	1	< 0.1%
50255	1	< 0.1%

qtde_produtcs
Real number (ℝ)

High correlation

Distinct	468
Distinct (%)	16.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	129.76884

Minimum	2
Maximum	7837
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	10
Q1	34
median	72
Q3	143
95-th percentile	400.2
Maximum	7837
Range	7835
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	277.76899
Coefficient of variation (CV)	2.1404907
Kurtosis	336.71947
Mean	129.76884
Median Absolute Deviation (MAD)	45
Skewness	15.345709
Sum	359849
Variance	77155.614
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	40	1.4%
35	34	1.2%
27	30	1.1%
26	30	1.1%
29	28	1.0%
31	27	1.0%
15	27	1.0%
33	27	1.0%
25	26	0.9%
42	26	0.9%
Other values (458)	2478	89.4%

Value	Count	Frequency (%)
2	11	0.4%
3	12	0.4%
4	16	0.6%
5	16	0.6%
6	24	0.9%
7	14	0.5%
8	13	0.5%
9	20	0.7%
10	18	0.6%
11	23	0.8%

Value	Count	Frequency (%)
7837	1	< 0.1%
5670	1	< 0.1%
5095	1	< 0.1%
4577	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1636	1	< 0.1%

avg_ticket
Real number (ℝ)

High correlation Skewed

Distinct	2771
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.106572

Minimum	2.1505882
Maximum	4453.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2.1505882
5-th percentile	4.8524538
Q1	12.41668
median	17.943444
Q3	25.025556
95-th percentile	87.757474
Maximum	4453.43
Range	4451.2794
Interquartile range (IQR)	12.608876

Descriptive statistics

Standard deviation	107.63141
Coefficient of variation (CV)	3.3523171
Kurtosis	1054.6276
Mean	32.106572
Median Absolute Deviation (MAD)	6.3346556
Skewness	27.678273
Sum	89031.523
Variance	11584.52
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.47833333	2	0.1%
4.162	2	0.1%
25.6761194	1	< 0.1%
44.95564103	1	< 0.1%
32.59775	1	< 0.1%
19.03048387	1	< 0.1%
28.55451613	1	< 0.1%
12.80068182	1	< 0.1%
6.396214689	1	< 0.1%
26.08797101	1	< 0.1%
Other values (2761)	2761	99.6%

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
4453.43	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%
602.4531323	1	< 0.1%

avg_recency_days
Real number (ℝ)

High correlation

Distinct	1155
Distinct (%)	41.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.756379

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	34.222222
median	59
Q3	99
95-th percentile	224
Maximum	366
Range	365
Interquartile range (IQR)	64.777778

Descriptive statistics

Standard deviation	66.483798
Coefficient of variation (CV)	0.84417032
Kurtosis	3.6897278
Mean	78.756379
Median Absolute Deviation (MAD)	30
Skewness	1.8311845
Sum	218391.44
Variance	4420.0954
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70	21	0.8%
46	18	0.6%
55	17	0.6%
49	16	0.6%
31	16	0.6%
91	16	0.6%
21	15	0.5%
35	15	0.5%
42	15	0.5%
28	14	0.5%
Other values (1145)	2610	94.1%

Value	Count	Frequency (%)
1	9	0.3%
2	4	0.1%
2.861538462	1	< 0.1%
3	6	0.2%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	5	0.2%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%
4.5	1	< 0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ)

High correlation Skewed

Distinct	1225
Distinct (%)	44.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.049706611

Minimum	0.0054495913
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0087463557
Q1	0.015789474
median	0.024390244
Q3	0.041666667
95-th percentile	0.11538462
Maximum	17
Range	16.99455
Interquartile range (IQR)	0.025877193

Descriptive statistics

Standard deviation	0.33765504
Coefficient of variation (CV)	6.7929604
Kurtosis	2295.7098
Mean	0.049706611
Median Absolute Deviation (MAD)	0.010691614
Skewness	46.077409
Sum	137.83643
Variance	0.11401092
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0625	17	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.6%
0.08333333333	15	0.5%
0.09090909091	15	0.5%
0.03448275862	14	0.5%
0.02941176471	14	0.5%
0.07692307692	13	0.5%
0.02127659574	13	0.5%
0.02564102564	13	0.5%
Other values (1215)	2626	94.7%

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	1	< 0.1%
1.142857143	1	< 0.1%
1	8	0.3%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

qtde_returns
Real number (ℝ)

Skewed Zeros

Distinct	204
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.973675

Minimum	0
Maximum	9014
Zeros	1481
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9
95-th percentile	96.8
Maximum	9014
Range	9014
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	290.71429
Coefficient of variation (CV)	8.3123747
Kurtosis	571.74568
Mean	34.973675
Median Absolute Deviation (MAD)	0
Skewness	21.626013
Sum	96982
Variance	84514.798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
6	63	2.3%
5	55	2.0%
12	45	1.6%
8	39	1.4%
9	38	1.4%
Other values (194)	652	23.5%

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
5	55	2.0%
6	63	2.3%
7	38	1.4%
8	39	1.4%
9	38	1.4%

Value	Count	Frequency (%)
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%

avg_basket_size
Real number (ℝ)

High correlation

Distinct	1931
Distinct (%)	69.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	230.94908

Minimum	1
Maximum	6009.3333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	45
Q1	103.33333
median	172
Q3	278.09524
95-th percentile	583.6
Maximum	6009.3333
Range	6008.3333
Interquartile range (IQR)	174.7619

Descriptive statistics

Standard deviation	261.5335
Coefficient of variation (CV)	1.1324293
Kurtosis	115.89887
Mean	230.94908
Median Absolute Deviation (MAD)	81
Skewness	7.7349287
Sum	640421.79
Variance	68399.773
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
86	9	0.3%
60	8	0.3%
75	8	0.3%
197	7	0.3%
73	7	0.3%
82	7	0.3%
136	7	0.3%
105	7	0.3%
208	7	0.3%
Other values (1921)	2695	97.2%

Value	Count	Frequency (%)
1	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%
11.875	1	< 0.1%

Value	Count	Frequency (%)
6009.333333	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%
2000	1	< 0.1%
1903.5	1	< 0.1%
1866.933333	1	< 0.1%

avg_unique_basket_size
Real number (ℝ)

High correlation

Distinct	902
Distinct (%)	32.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.141537

Minimum	0.2
Maximum	177
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.5454545
median	13.5
Q3	22
95-th percentile	45.1
Maximum	177
Range	176.8
Interquartile range (IQR)	14.454545

Descriptive statistics

Standard deviation	14.265048
Coefficient of variation (CV)	0.8321919
Kurtosis	9.9923133
Mean	17.141537
Median Absolute Deviation (MAD)	6.6666667
Skewness	2.2443707
Sum	47533.482
Variance	203.4916
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	34	1.2%
16	34	1.2%
13	34	1.2%
9	33	1.2%
7	32	1.2%
12	30	1.1%
18.5	29	1.0%
6	29	1.0%
14	28	1.0%
17	28	1.0%
Other values (892)	2462	88.8%

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
177	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%
93	1	< 0.1%
89.625	1	< 0.1%
87	1	< 0.1%
85.66666667	1	< 0.1%

	avg_basket_size	avg_recency_days	avg_ticket	avg_unique_basket_size	customer_id	frequency	gross_revenue	qtde_produtcs	qtde_returns	qte_invoices	qte_items	recency_days
avg_basket_size	1.000	-0.043	0.198	0.384	-0.121	0.026	0.602	0.403	0.214	0.126	0.759	-0.103
avg_recency_days	-0.043	1.000	-0.080	0.187	-0.012	-0.952	-0.367	-0.300	-0.215	-0.476	-0.344	0.225
avg_ticket	0.198	-0.080	1.000	-0.639	-0.141	0.082	0.273	-0.381	0.188	0.091	0.195	0.035
avg_unique_basket_size	0.384	0.187	-0.639	1.000	-0.001	-0.166	0.104	0.546	-0.064	-0.180	0.147	0.005
customer_id	-0.121	-0.012	-0.141	-0.001	1.000	0.014	-0.086	0.013	-0.058	0.013	-0.079	0.014
frequency	0.026	-0.952	0.082	-0.166	0.014	1.000	0.259	0.201	0.176	0.322	0.240	-0.127
gross_revenue	0.602	-0.367	0.273	0.104	-0.086	0.259	1.000	0.723	0.461	0.763	0.922	-0.373
qtde_produtcs	0.403	-0.300	-0.381	0.546	0.013	0.201	0.723	1.000	0.329	0.659	0.709	-0.392
qtde_returns	0.214	-0.215	0.188	-0.064	-0.058	0.176	0.461	0.329	1.000	0.427	0.426	-0.186
qte_invoices	0.126	-0.476	0.091	-0.180	0.013	0.322	0.763	0.659	0.427	1.000	0.704	-0.448
qte_items	0.759	-0.344	0.195	0.147	-0.079	0.240	0.922	0.709	0.426	0.704	1.000	-0.365
recency_days	-0.103	0.225	0.035	0.005	0.014	-0.127	-0.373	-0.392	-0.186	-0.448	-0.365	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	customer_id	gross_revenue	recency_days	qte_invoices	qte_items	qtde_produtcs	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
0	17850	5391.21	372.0	34.0	1733.0	297.0	18.152222	1.000000	17.000000	40.0	50.970588	0.617647
1	13047	3232.59	56.0	9.0	1390.0	171.0	18.904035	52.833333	0.028302	35.0	154.444444	11.666667
2	12583	6705.38	2.0	15.0	5028.0	232.0	28.902500	26.500000	0.040323	50.0	335.200000	7.600000
3	13748	948.25	95.0	5.0	439.0	28.0	33.866071	92.666667	0.017921	0.0	87.800000	4.800000
4	15100	876.00	333.0	3.0	80.0	3.0	292.000000	20.000000	0.073171	22.0	26.666667	0.333333
5	15291	4623.30	25.0	14.0	2102.0	102.0	45.326471	26.769231	0.040115	29.0	150.142857	4.357143
6	14688	5630.87	7.0	21.0	3621.0	327.0	17.219786	19.263158	0.057221	399.0	172.428571	7.047619
7	17809	5411.91	16.0	12.0	2057.0	61.0	88.719836	39.666667	0.033520	41.0	171.416667	3.833333
8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.543464	4.191011	0.243316	474.0	419.714286	6.230769
9	16098	2005.63	87.0	7.0	613.0	67.0	29.934776	47.666667	0.024390	0.0	87.571429	4.857143

	customer_id	gross_revenue	recency_days	qte_invoices	qte_items	qtde_produtcs	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
5610	17290	525.24	3.0	2.0	404.0	102.0	5.149412	13.0	0.142857	0.0	202.000000	46.000000
5619	14785	77.40	10.0	2.0	84.0	3.0	25.800000	5.0	0.333333	0.0	42.000000	1.000000
5620	17254	272.44	4.0	2.0	252.0	112.0	2.432500	11.0	0.166667	0.0	126.000000	50.000000
5636	17232	421.52	2.0	2.0	203.0	36.0	11.708889	12.0	0.153846	0.0	101.500000	15.000000
5637	17468	137.00	10.0	2.0	116.0	5.0	27.400000	4.0	0.400000	0.0	58.000000	2.500000
5648	13596	697.04	5.0	2.0	406.0	166.0	4.199036	7.0	0.250000	0.0	203.000000	66.500000
5654	14893	1237.85	9.0	2.0	799.0	73.0	16.956849	2.0	0.666667	0.0	399.500000	36.000000
5679	14126	706.13	7.0	3.0	508.0	15.0	47.075333	3.0	0.750000	50.0	169.333333	4.666667
5685	13521	1092.39	1.0	3.0	733.0	435.0	2.511241	4.5	0.300000	0.0	244.333333	104.000000
5695	15060	301.84	8.0	4.0	262.0	120.0	2.515333	1.0	2.000000	0.0	65.500000	20.000000

Overview

Interactions

Correlations

Missing values

Sample

Overview

Variables

Interactions

Correlations

Missing values

Sample